﻿using FarPoint.Win.Spread;
using GrapeCity.CalcEngine;
using GrapeCity.Spreadsheet.Localization;
using Spread.Common.Features.Sample;
using System;
using System.Data;
using System.Linq;
using System.Reflection;
using System.Windows.Forms;

namespace Spread.Calculation.Features
{
    public partial class LanguagePackagesDemo : BaseSampleControl
    {
        public LanguagePackagesDemo()
        {
            InitializeComponent();
            SetupMenu();
            SetupSpreadsheet();
        }

        private void SetupMenu()
        {
            ToolStripMenuItem def = (ToolStripMenuItem)languagePackageToolStripMenuItem.DropDownItems.Add("English", null, onLanguageSelected);
            def.Tag = fpSpread1.AsWorkbook().WorkbookSet.LanguagePackage;
            def.Checked = true;
            foreach (PropertyInfo p in typeof(LanguagePackage).GetProperties().Where(p => p.PropertyType == typeof(LanguagePackage)))
            {
                ToolStripItem item = languagePackageToolStripMenuItem.DropDownItems.Add(p.Name, null, onLanguageSelected);
                item.Tag = typeof(LanguagePackage).GetProperty(p.Name).GetValue(def.Tag);
            }
            languagePackageToolStripMenuItem.DropDownItems.Add("-");
            ToolStripItem custom = languagePackageToolStripMenuItem.DropDownItems.Add("Custom French", null, onLanguageSelected);
            custom.Tag = CreateCustomFrenchLanguagePackage();
        }

        private void SetupSpreadsheet()
        {
            fpSpread1.Sheets[0].ColumnHeaderRowCount = 3;
            fpSpread1.Sheets[0].RowHeaderColumnCount = 3;
            fpSpread1.Sheets[0].ColumnFooterRowCount = 3;
            fpSpread1.Sheets[0].ColumnFooterVisible = true;
            fpSpread1.Sheets[0].Cells[1, 1].Text = "Last Name";
            fpSpread1.Sheets[0].Cells[1, 2].Text = "Value";
            fpSpread1.Sheets[0].Cells[2, 1].Text = "Smith";
            fpSpread1.Sheets[0].Cells[2, 2].Value = 50;
            fpSpread1.Sheets[0].Cells[3, 1].Text = "Vil";
            fpSpread1.Sheets[0].Cells[3, 2].Value = 10;
            fpSpread1.Sheets[0].Cells[4, 1].Text = "Press";
            fpSpread1.Sheets[0].Cells[4, 2].Value = 78;
            TableView t = fpSpread1.Sheets[0].AddTable("table", 1, 1, 5, 2);
            fpSpread1.Sheets[0].ColumnHeader.Cells[1, 0].Text = "Sum of Value:";
            fpSpread1.Sheets[0].ColumnHeader.Cells[1, 0].ColumnSpan = 2;
            fpSpread1.Sheets[0].ColumnFooter.Cells[1, 0].Text = "Average of Value:";
            fpSpread1.Sheets[0].ColumnFooter.Cells[1, 0].ColumnSpan = 2;
            fpSpread1.Sheets[0].RowHeader.Cells[1, 0].Text = "STDEV of Value:";
            fpSpread1.Sheets[0].RowHeader.Cells[1, 0].ColumnSpan = 2;
            fpSpread1.Sheets[0].RowHeader.Rows[1].Height = 2 * fpSpread1.Sheets[0].RowHeader.Rows[1].Height;
            fpSpread1.AsWorkbook().Worksheets[0].ColumnHeader.Cells[1, 2].Style.NumberFormat = "0.00";
            fpSpread1.AsWorkbook().Worksheets[0].RowHeader.Cells[2, 0].Style.NumberFormat = "0.00";
            fpSpread1.AsWorkbook().Worksheets[0].ColumnFooter.Cells[1, 2].Style.NumberFormat = "0.00";
            fpSpread1.Sheets[0].ColumnHeader.Cells[1, 2].Formula = "SUM(table[Value])";
            fpSpread1.Sheets[0].ColumnFooter.Cells[1, 2].Formula = "AVERAGE(table[Value])";
            fpSpread1.Sheets[0].RowHeader.Cells[2, 0].Formula = "STDEV(table[Value])";
            fpSpread1.Sheets[0].RowHeader.Cells[2, 0].ColumnSpan = 2;
            t.TotalRowVisible = true;
            fpSpread1.ActiveSheet.Cells[0, 1].Formula = "\"Total of \"&table[[#Headers],[Value]]";
            fpSpread1.ActiveSheet.Cells[0, 1].ColumnSpan = 2;
            fpSpread1.ActiveSheet.Cells[0, 3].Formula = "table[[#Totals],[Value]]";
            fpSpread1.ActiveSheet.Cells[7, 1].ColumnSpan = 2;
            fpSpread1.ActiveSheet.Cells[7, 1].Text = "Sum of Value:";
            fpSpread1.ActiveSheet.Cells[8, 1].ColumnSpan = 2;
            fpSpread1.ActiveSheet.Cells[8, 1].Text = "Average of Value:";
            fpSpread1.ActiveSheet.Cells[9, 1].ColumnSpan = 2;
            fpSpread1.ActiveSheet.Cells[9, 1].Text = "STDEV of Value:";
            fpSpread1.ActiveSheet.Cells[7, 3].Formula = "Sheet1[[#Headers],[$C$2]]";
            fpSpread1.ActiveSheet.Cells[8, 3].Formula = "Sheet1[[#Totals],[$C$2]]";
            fpSpread1.ActiveSheet.Cells[9, 3].Formula = "Sheet1[[#RowHeaders],[$A$3]]";
            fpSpread1_Sheet1.SetFormula(0, 0, "SUM(A2:A10)");
            fpSpread1_Sheet1.SetActiveCell(0, 3);
            fpSpread1.StatusBarVisible = true;
        }

        private void onLanguageSelected(object sender, EventArgs e)
        {
            ToolStripMenuItem selected = (ToolStripMenuItem)sender;
            foreach (object item in ((ToolStripMenuItem)selected.OwnerItem).DropDownItems)
                if (item is ToolStripMenuItem)
                    ((ToolStripMenuItem)item).Checked = false;
            fpSpread1.AsWorkbook().WorkbookSet.LanguagePackage = (LanguagePackage)selected.Tag;
            selected.Checked = true;
            if(!string.IsNullOrEmpty(fpSpread1.ActiveSheet.ActiveCell.Formula))
              fpSpread1.ActiveSheet.ActiveCell.Formula = fpSpread1.ActiveSheet.ActiveCell.Formula;
        }

        private LanguagePackage CreateCustomFrenchLanguagePackage()
        {
            LanguagePackage languagePackage = new LanguagePackage("CustomFrench", "français");
            languagePackage.CreateAlias(BuiltinFunction.ACCRINT, "INTERET.ACC");
            languagePackage.CreateAlias(BuiltinFunction.ACCRINTM, "INTERET.ACC.MAT");
            languagePackage.CreateAlias(BuiltinFunction.ADDRESS, "ADRESSE");
            languagePackage.CreateAlias(BuiltinFunction.AGGREGATE, "AGREGAT");
            languagePackage.CreateAlias(BuiltinFunction.AND, "ET");
            languagePackage.CreateAlias(BuiltinFunction.ARABIC, "CHIFFRE.ARABE");
            languagePackage.CreateAlias(BuiltinFunction.AREAS, "ZONES");
            languagePackage.CreateAlias(BuiltinFunction.AVEDEV, "ECART.MOYEN");
            languagePackage.CreateAlias(BuiltinFunction.AVERAGE, "MOYENNE");
            languagePackage.CreateAlias(BuiltinFunction.AVERAGEIF, "MOYENNE.SI");
            languagePackage.CreateAlias(BuiltinFunction.AVERAGEIFS, "MOYENNE.SI.ENS");
            languagePackage.CreateAlias(BuiltinFunction.BETA_DIST, "LOI.BETA.N");
            languagePackage.CreateAlias(BuiltinFunction.BETA_INV, "BETA.INVERSE.N");
            languagePackage.CreateAlias(BuiltinFunction.BETADIST, "LOI.BETA");
            languagePackage.CreateAlias(BuiltinFunction.BETAINV, "BETA.INVERSE");
            languagePackage.CreateAlias(BuiltinFunction.BIN2DEC, "BINDEC");
            languagePackage.CreateAlias(BuiltinFunction.BIN2HEX, "BINHEX");
            languagePackage.CreateAlias(BuiltinFunction.BIN2OCT, "BINOCT");
            languagePackage.CreateAlias(BuiltinFunction.BINOM_DIST, "LOI.BINOMIALE.N");
            languagePackage.CreateAlias(BuiltinFunction.BINOM_INV, "LOI.BINOMIALE.INVERSE");
            languagePackage.CreateAlias(BuiltinFunction.BINOMDIST, "LOI.BINOMIALE");
            languagePackage.CreateAlias(BuiltinFunction.BITAND, "BITET");
            languagePackage.CreateAlias(BuiltinFunction.BITOR, "BITOU");
            languagePackage.CreateAlias(BuiltinFunction.BITRSHIFT, "BITDECALD");
            languagePackage.CreateAlias(BuiltinFunction.BITXOR, "BITOUEXCLUSIF");
            languagePackage.CreateAlias(BuiltinFunction.CEILING, "PLAFOND");
            languagePackage.CreateAlias(BuiltinFunction.CEILING_MATH, "PLAFOND.MATH");
            languagePackage.CreateAlias(BuiltinFunction.CEILING_PRECISE, "PLAFOND.PRECIS");
            languagePackage.CreateAlias(BuiltinFunction.CELL, "CELLULE");
            languagePackage.CreateAlias(BuiltinFunction.CHAR, "CAR");
            languagePackage.CreateAlias(BuiltinFunction.CHIDIST, "KHIDEUX");
            languagePackage.CreateAlias(BuiltinFunction.CHIINV, "KHIDEUX.INVERSE");
            languagePackage.CreateAlias(BuiltinFunction.CHISQ_DIST, "LOI.KHIDEUX");
            languagePackage.CreateAlias(BuiltinFunction.CHISQ_DIST_RT, "LOI.KHIDEUX.DROITE");
            languagePackage.CreateAlias(BuiltinFunction.CHISQ_INV, "LOI.KHIDEUX.INVERSE");
            languagePackage.CreateAlias(BuiltinFunction.CHISQ_INV_RT, "LOI.KHIDEUX.INVERSE.DROITE");
            languagePackage.CreateAlias(BuiltinFunction.CHITEST, "TEST.KHIDEUX");
            languagePackage.CreateAlias(BuiltinFunction.CHOOSE, "CHOISIR");
            languagePackage.CreateAlias(BuiltinFunction.CLEAN, "EPURAGE");
            languagePackage.CreateAlias(BuiltinFunction.COLUMN, "COLONNE");
            languagePackage.CreateAlias(BuiltinFunction.COLUMNS, "COLONNES");
            languagePackage.CreateAlias(BuiltinFunction.COMPLEX, "COMPLEXE");
            languagePackage.CreateAlias(BuiltinFunction.CONCATENATE, "CONCATENER");
            languagePackage.CreateAlias(BuiltinFunction.CONFIDENCE, "INTERVALLE.CONFIANCE");
            languagePackage.CreateAlias(BuiltinFunction.CONFIDENCE_NORM, "INTERVALLE.CONFIANCE.NORMAL");
            languagePackage.CreateAlias(BuiltinFunction.CONFIDENCE_T, "INTERVALLE.CONFIANCE.STUDENT");
            languagePackage.CreateAlias(BuiltinFunction.CORREL, "COEFFICIENT.CORRELATION");
            languagePackage.CreateAlias(BuiltinFunction.COUNT, "NB");
            languagePackage.CreateAlias(BuiltinFunction.COUNTA, "NBVAL");
            languagePackage.CreateAlias(BuiltinFunction.COUNTBLANK, "NB.VIDE");
            languagePackage.CreateAlias(BuiltinFunction.COUNTIF, "NB.SI");
            languagePackage.CreateAlias(BuiltinFunction.COUNTIFS, "NB.SI.ENS");
            languagePackage.CreateAlias(BuiltinFunction.COUPDAYBS, "NB.JOURS.COUPON.PREC");
            languagePackage.CreateAlias(BuiltinFunction.COUPDAYS, "NB.JOURS.COUPONS");
            languagePackage.CreateAlias(BuiltinFunction.COUPDAYSNC, "NB.JOURS.COUPON.SUIV");
            languagePackage.CreateAlias(BuiltinFunction.COUPNCD, "DATE.COUPON.SUIV");
            languagePackage.CreateAlias(BuiltinFunction.COUPNUM, "NB.COUPONS");
            languagePackage.CreateAlias(BuiltinFunction.COUPPCD, "DATE.COUPON.PREC");
            languagePackage.CreateAlias(BuiltinFunction.COVAR, "COVARIANCE");
            languagePackage.CreateAlias(BuiltinFunction.COVARIANCE_P, "COVARIANCE.PEARSON");
            languagePackage.CreateAlias(BuiltinFunction.COVARIANCE_S, "COVARIANCE.STANDARD");
            languagePackage.CreateAlias(BuiltinFunction.CRITBINOM, "CRITERE.LOI.BINOMIALE");
            languagePackage.CreateAlias(BuiltinFunction.CUMIPMT, "CUMUL.INTER");
            languagePackage.CreateAlias(BuiltinFunction.CUMPRINC, "CUMUL.PRINCPER");
            languagePackage.CreateAlias(BuiltinFunction.DATEVALUE, "DATEVAL");
            languagePackage.CreateAlias(BuiltinFunction.DAVERAGE, "BDMOYENNE");
            languagePackage.CreateAlias(BuiltinFunction.DAY, "JOUR");
            languagePackage.CreateAlias(BuiltinFunction.DAYS, "JOURS");
            languagePackage.CreateAlias(BuiltinFunction.DAYS360, "JOURS360");
            languagePackage.CreateAlias(BuiltinFunction.DCOUNT, "BDNB");
            languagePackage.CreateAlias(BuiltinFunction.DCOUNTA, "BDNBVAL");
            languagePackage.CreateAlias(BuiltinFunction.DEC2BIN, "DECBIN");
            languagePackage.CreateAlias(BuiltinFunction.DEC2HEX, "DECHEX");
            languagePackage.CreateAlias(BuiltinFunction.DEC2OCT, "DECOCT");
            languagePackage.CreateAlias(BuiltinFunction.DEGREES, "DEGRES");
            languagePackage.CreateAlias(BuiltinFunction.DEVSQ, "SOMME.CARRES.ECARTS");
            languagePackage.CreateAlias(BuiltinFunction.DGET, "BDLIRE");
            languagePackage.CreateAlias(BuiltinFunction.DISC, "TAUX.ESCOMPTE");
            languagePackage.CreateAlias(BuiltinFunction.DMAX, "BDMAX");
            languagePackage.CreateAlias(BuiltinFunction.DMIN, "BDMIN");
            languagePackage.CreateAlias(BuiltinFunction.DOLLAR, "DEVISE");
            languagePackage.CreateAlias(BuiltinFunction.DOLLARDE, "PRIX.DEC");
            languagePackage.CreateAlias(BuiltinFunction.DOLLARFR, "PRIX.FRAC");
            languagePackage.CreateAlias(BuiltinFunction.DPRODUCT, "BDPRODUIT");
            languagePackage.CreateAlias(BuiltinFunction.DSTDEV, "BDECARTYPE");
            languagePackage.CreateAlias(BuiltinFunction.DSTDEVP, "BDECARTYPEP");
            languagePackage.CreateAlias(BuiltinFunction.DSUM, "BDSOMME");
            languagePackage.CreateAlias(BuiltinFunction.DURATION, "DUREE");
            languagePackage.CreateAlias(BuiltinFunction.DVAR, "BDVAR");
            languagePackage.CreateAlias(BuiltinFunction.DVARP, "BDVARP");
            languagePackage.CreateAlias(BuiltinFunction.EDATE, "MOIS.DECALER");
            languagePackage.CreateAlias(BuiltinFunction.EFFECT, "TAUX.EFFECTIF");
            languagePackage.CreateAlias(BuiltinFunction.EOMONTH, "FIN.MOIS");
            languagePackage.CreateAlias(BuiltinFunction.ERF_PRECISE, "ERF.PRECIS");
            languagePackage.CreateAlias(BuiltinFunction.ERFC_PRECISE, "ERFC.PRECIS");
            languagePackage.CreateAlias(BuiltinFunction.ERROR_TYPE, "TYPE.ERREUR");
            languagePackage.CreateAlias(BuiltinFunction.EVEN, "PAIR");
            languagePackage.CreateAlias(BuiltinFunction.EXPON_DIST, "LOI.EXPONENTIELLE.N");
            languagePackage.CreateAlias(BuiltinFunction.EXPONDIST, "LOI.EXPONENTIELLE");
            languagePackage.CreateAlias(BuiltinFunction.F_DIST, "LOI.F.N");
            languagePackage.CreateAlias(BuiltinFunction.F_DIST_RT, "LOI.F.DROITE");
            languagePackage.CreateAlias(BuiltinFunction.F_INV, "INVERSE.LOI.F.N");
            languagePackage.CreateAlias(BuiltinFunction.F_INV_RT, "INVERSE.LOI.F.DROITE");
            languagePackage.CreateAlias(BuiltinFunction.FALSE, "FAUX");
            languagePackage.CreateAlias(BuiltinFunction.FDIST, "LOI.F");
            languagePackage.CreateAlias(BuiltinFunction.FILTERXML, "FILTRE.XML");
            languagePackage.CreateAlias(BuiltinFunction.FIND, "TROUVE");
            languagePackage.CreateAlias(BuiltinFunction.FINDB, "TROUVERB");
            languagePackage.CreateAlias(BuiltinFunction.FINV, "INVERSE.LOI.F");
            languagePackage.CreateAlias(BuiltinFunction.FISHERINV, "FISHER.INVERSE");
            languagePackage.CreateAlias(BuiltinFunction.FIXED, "CTXT");
            languagePackage.CreateAlias(BuiltinFunction.FLOOR, "PLANCHER");
            languagePackage.CreateAlias(BuiltinFunction.FLOOR_MATH, "PLANCHER.MATH");
            languagePackage.CreateAlias(BuiltinFunction.FLOOR_PRECISE, "PLANCHER.PRECIS");
            languagePackage.CreateAlias(BuiltinFunction.FORECAST, "PREVISION");
            languagePackage.CreateAlias(BuiltinFunction.FREQUENCY, "FREQUENCE");
            languagePackage.CreateAlias(BuiltinFunction.FTEST, "TEST.F");
            languagePackage.CreateAlias(BuiltinFunction.FV, "VC");
            languagePackage.CreateAlias(BuiltinFunction.FVSCHEDULE, "VC.PAIEMENTS");
            languagePackage.CreateAlias(BuiltinFunction.GAMMA_DIST, "LOI.GAMMA.N");
            languagePackage.CreateAlias(BuiltinFunction.GAMMA_INV, "LOI.GAMMA.INVERSE.N");
            languagePackage.CreateAlias(BuiltinFunction.GAMMADIST, "LOI.GAMMA");
            languagePackage.CreateAlias(BuiltinFunction.GAMMAINV, "LOI.GAMMA.INVERSE");
            languagePackage.CreateAlias(BuiltinFunction.GAMMALN, "LNGAMMA");
            languagePackage.CreateAlias(BuiltinFunction.GAMMALN_PRECISE, "LNGAMMA.PRECIS");
            languagePackage.CreateAlias(BuiltinFunction.GCD, "PGCD");
            languagePackage.CreateAlias(BuiltinFunction.GEOMEAN, "MOYENNE.GEOMETRIQUE");
            languagePackage.CreateAlias(BuiltinFunction.GESTEP, "SUP.SEUIL");
            languagePackage.CreateAlias(BuiltinFunction.GROWTH, "CROISSANCE");
            languagePackage.CreateAlias(BuiltinFunction.HARMEAN, "MOYENNE.HARMONIQUE");
            languagePackage.CreateAlias(BuiltinFunction.HEX2BIN, "HEXBIN");
            languagePackage.CreateAlias(BuiltinFunction.HEX2DEC, "HEXDEC");
            languagePackage.CreateAlias(BuiltinFunction.HEX2OCT, "HEXOCT");
            languagePackage.CreateAlias(BuiltinFunction.HLOOKUP, "RECHERCHEH");
            languagePackage.CreateAlias(BuiltinFunction.HOUR, "HEURE");
            languagePackage.CreateAlias(BuiltinFunction.HYPERLINK, "LIEN_HYPERTEXTE");
            languagePackage.CreateAlias(BuiltinFunction.HYPGEOM_DIST, "LOI.HYPERGEOMETRIQUE.N");
            languagePackage.CreateAlias(BuiltinFunction.HYPGEOMDIST, "LOI.HYPERGEOMETRIQUE");
            languagePackage.CreateAlias(BuiltinFunction.IF, "SI");
            languagePackage.CreateAlias(BuiltinFunction.IFERROR, "SIERREUR");
            languagePackage.CreateAlias(BuiltinFunction.IFNA, "SI.NON.DISP");
            languagePackage.CreateAlias(BuiltinFunction.IMABS, "COMPLEXE.MODULE");
            languagePackage.CreateAlias(BuiltinFunction.IMAGINARY, "COMPLEXE.IMAGINAIRE");
            languagePackage.CreateAlias(BuiltinFunction.IMARGUMENT, "COMPLEXE.ARGUMENT");
            languagePackage.CreateAlias(BuiltinFunction.IMCONJUGATE, "COMPLEXE.CONJUGUE");
            languagePackage.CreateAlias(BuiltinFunction.IMCOS, "COMPLEXE.COS");
            languagePackage.CreateAlias(BuiltinFunction.IMCOSH, "COMPLEXE.COSH");
            languagePackage.CreateAlias(BuiltinFunction.IMCSC, "COMPLEXE.CSC");
            languagePackage.CreateAlias(BuiltinFunction.IMCSCH, "COMPLEXE.CSCH");
            languagePackage.CreateAlias(BuiltinFunction.IMDIV, "COMPLEXE.DIV");
            languagePackage.CreateAlias(BuiltinFunction.IMEXP, "COMPLEXE.EXP");
            languagePackage.CreateAlias(BuiltinFunction.IMLN, "COMPLEXE.LN");
            languagePackage.CreateAlias(BuiltinFunction.IMLOG10, "COMPLEXE.LOG10");
            languagePackage.CreateAlias(BuiltinFunction.IMLOG2, "COMPLEXE.LOG2");
            languagePackage.CreateAlias(BuiltinFunction.IMPOWER, "COMPLEXE.PUISSANCE");
            languagePackage.CreateAlias(BuiltinFunction.IMPRODUCT, "COMPLEXE.PRODUIT");
            languagePackage.CreateAlias(BuiltinFunction.IMREAL, "COMPLEXE.REEL");
            languagePackage.CreateAlias(BuiltinFunction.IMSEC, "COMPLEXE.SEC");
            languagePackage.CreateAlias(BuiltinFunction.IMSECH, "COMPLEXE.SECH");
            languagePackage.CreateAlias(BuiltinFunction.IMSIN, "COMPLEXE.SIN");
            languagePackage.CreateAlias(BuiltinFunction.IMSINH, "COMPLEXE.SINH");
            languagePackage.CreateAlias(BuiltinFunction.IMSQRT, "COMPLEXE.RACINE");
            languagePackage.CreateAlias(BuiltinFunction.IMSUB, "COMPLEXE.DIFFERENCE");
            languagePackage.CreateAlias(BuiltinFunction.IMSUM, "COMPLEXE.SOMME");
            languagePackage.CreateAlias(BuiltinFunction.INFO, "INFORMATIONS");
            languagePackage.CreateAlias(BuiltinFunction.INT, "ENT");
            languagePackage.CreateAlias(BuiltinFunction.INTERCEPT, "ORDONNEE.ORIGINE");
            languagePackage.CreateAlias(BuiltinFunction.INTRATE, "TAUX.INTERET");
            languagePackage.CreateAlias(BuiltinFunction.IPMT, "INTPER");
            languagePackage.CreateAlias(BuiltinFunction.IRR, "TRI");
            languagePackage.CreateAlias(BuiltinFunction.ISBLANK, "ESTVIDE");
            languagePackage.CreateAlias(BuiltinFunction.ISERR, "ESTERR");
            languagePackage.CreateAlias(BuiltinFunction.ISERROR, "ESTERREUR");
            languagePackage.CreateAlias(BuiltinFunction.ISEVEN, "EST.PAIR");
            languagePackage.CreateAlias(BuiltinFunction.ISLOGICAL, "ESTLOGIQUE");
            languagePackage.CreateAlias(BuiltinFunction.ISNA, "ESTNA");
            languagePackage.CreateAlias(BuiltinFunction.ISNONTEXT, "ESTNONTEXTE");
            languagePackage.CreateAlias(BuiltinFunction.ISNUMBER, "ESTNUM");
            languagePackage.CreateAlias(BuiltinFunction.ISO_CEILING, "ISO.PLAFOND");
            languagePackage.CreateAlias(BuiltinFunction.ISODD, "EST.IMPAIR");
            languagePackage.CreateAlias(BuiltinFunction.ISREF, "ESTREF");
            languagePackage.CreateAlias(BuiltinFunction.ISTEXT, "ESTTEXTE");
            languagePackage.CreateAlias(BuiltinFunction.KURT, "KURTOSIS");
            languagePackage.CreateAlias(BuiltinFunction.LARGE, "GRANDE.VALEUR");
            languagePackage.CreateAlias(BuiltinFunction.LCM, "PPCM");
            languagePackage.CreateAlias(BuiltinFunction.LEFT, "GAUCHE");
            languagePackage.CreateAlias(BuiltinFunction.LEFTB, "GAUCHEB");
            languagePackage.CreateAlias(BuiltinFunction.LEN, "NBCAR");
            languagePackage.CreateAlias(BuiltinFunction.LENB, "LENB");
            languagePackage.CreateAlias(BuiltinFunction.LINEST, "DROITEREG");
            languagePackage.CreateAlias(BuiltinFunction.LOGEST, "LOGREG");
            languagePackage.CreateAlias(BuiltinFunction.LOGINV, "LOI.LOGNORMALE.INVERSE");
            languagePackage.CreateAlias(BuiltinFunction.LOGNORM_DIST, "LOI.LOGNORMALE.N");
            languagePackage.CreateAlias(BuiltinFunction.LOGNORM_INV, "LOI.LOGNORMALE.INVERSE.N");
            languagePackage.CreateAlias(BuiltinFunction.LOGNORMDIST, "LOI.LOGNORMALE");
            languagePackage.CreateAlias(BuiltinFunction.LOOKUP, "RECHERCHE");
            languagePackage.CreateAlias(BuiltinFunction.LOWER, "MINUSCULE");
            languagePackage.CreateAlias(BuiltinFunction.MATCH, "EQUIV");
            languagePackage.CreateAlias(BuiltinFunction.MDETERM, "DETERMAT");
            languagePackage.CreateAlias(BuiltinFunction.MDURATION, "DUREE.MODIFIEE");
            languagePackage.CreateAlias(BuiltinFunction.MEDIAN, "MEDIANE");
            languagePackage.CreateAlias(BuiltinFunction.MID, "STXT");
            languagePackage.CreateAlias(BuiltinFunction.MINVERSE, "INVERSEMAT");
            languagePackage.CreateAlias(BuiltinFunction.MIRR, "TRIM");
            languagePackage.CreateAlias(BuiltinFunction.MMULT, "PRODUITMAT");
            languagePackage.CreateAlias(BuiltinFunction.MODE_MULT, "MODE.MULTIPLE");
            languagePackage.CreateAlias(BuiltinFunction.MODE_SNGL, "MODE.SIMPLE");
            languagePackage.CreateAlias(BuiltinFunction.MONTH, "MOIS");
            languagePackage.CreateAlias(BuiltinFunction.MROUND, "ARRONDI.AU.MULTIPLE");
            languagePackage.CreateAlias(BuiltinFunction.MULTINOMIAL, "MULTINOMIALE");
            languagePackage.CreateAlias(BuiltinFunction.MUNIT, "MATRICE.UNITAIRE");
            languagePackage.CreateAlias(BuiltinFunction.NEGBINOM_DIST, "LOI.BINOMIALE.NEG.N");
            languagePackage.CreateAlias(BuiltinFunction.NEGBINOMDIST, "LOI.BINOMIALE.NEG");
            languagePackage.CreateAlias(BuiltinFunction.NETWORKDAYS, "NB.JOURS.OUVRES");
            languagePackage.CreateAlias(BuiltinFunction.NETWORKDAYS_INTL, "NB.JOURS.OUVRES.INTL");
            languagePackage.CreateAlias(BuiltinFunction.NOMINAL, "TAUX.NOMINAL");
            languagePackage.CreateAlias(BuiltinFunction.NORM_DIST, "LOI.NORMALE.N");
            languagePackage.CreateAlias(BuiltinFunction.NORM_INV, "LOI.NORMALE.INVERSE.N");
            languagePackage.CreateAlias(BuiltinFunction.NORM_S_DIST, "LOI.NORMALE.STANDARD.N");
            languagePackage.CreateAlias(BuiltinFunction.NORM_S_INV, "LOI.NORMALE.STANDARD.INVERSE.N");
            languagePackage.CreateAlias(BuiltinFunction.NORMDIST, "LOI.NORMALE");
            languagePackage.CreateAlias(BuiltinFunction.NORMINV, "LOI.NORMALE.INVERSE");
            languagePackage.CreateAlias(BuiltinFunction.NORMSDIST, "LOI.NORMALE.STANDARD");
            languagePackage.CreateAlias(BuiltinFunction.NORMSINV, "LOI.NORMALE.STANDARD.INVERSE");
            languagePackage.CreateAlias(BuiltinFunction.NOT, "NON");
            languagePackage.CreateAlias(BuiltinFunction.NOW, "MAINTENANT");
            languagePackage.CreateAlias(BuiltinFunction.NPER, "NPM");
            languagePackage.CreateAlias(BuiltinFunction.NPV, "VAN");
            languagePackage.CreateAlias(BuiltinFunction.OCT2BIN, "OCTBIN");
            languagePackage.CreateAlias(BuiltinFunction.OCT2DEC, "OCTDEC");
            languagePackage.CreateAlias(BuiltinFunction.OCT2HEX, "OCTHEX");
            languagePackage.CreateAlias(BuiltinFunction.ODD, "IMPAIR");
            languagePackage.CreateAlias(BuiltinFunction.ODDFPRICE, "PRIX.PCOUPON.IRREG");
            languagePackage.CreateAlias(BuiltinFunction.ODDFYIELD, "REND.PCOUPON.IRREG");
            languagePackage.CreateAlias(BuiltinFunction.ODDLPRICE, "PRIX.DCOUPON.IRREG");
            languagePackage.CreateAlias(BuiltinFunction.ODDLYIELD, "REND.DCOUPON.IRREG");
            languagePackage.CreateAlias(BuiltinFunction.OFFSET, "DECALER");
            languagePackage.CreateAlias(BuiltinFunction.OR, "OU");
            languagePackage.CreateAlias(BuiltinFunction.PERCENTILE, "CENTILE");
            languagePackage.CreateAlias(BuiltinFunction.PERCENTILE_EXC, "CENTILE.EXCLURE");
            languagePackage.CreateAlias(BuiltinFunction.PERCENTILE_INC, "CENTILE.INCLURE");
            languagePackage.CreateAlias(BuiltinFunction.PERCENTRANK, "RANG.POURCENTAGE");
            languagePackage.CreateAlias(BuiltinFunction.PERCENTRANK_EXC, "RANG.POURCENTAGE.EXCLURE");
            languagePackage.CreateAlias(BuiltinFunction.PERCENTRANK_INC, "RANG.POURCENTAGE.INCLURE");
            languagePackage.CreateAlias(BuiltinFunction.PERMUT, "PERMUTATION");
            languagePackage.CreateAlias(BuiltinFunction.PMT, "VPM");
            languagePackage.CreateAlias(BuiltinFunction.POISSON, "LOI.POISSON");
            languagePackage.CreateAlias(BuiltinFunction.POISSON_DIST, "LOI.POISSON.N");
            languagePackage.CreateAlias(BuiltinFunction.POWER, "PUISSANCE");
            languagePackage.CreateAlias(BuiltinFunction.PPMT, "PRINCPER");
            languagePackage.CreateAlias(BuiltinFunction.PRICE, "PRIX.TITRE");
            languagePackage.CreateAlias(BuiltinFunction.PRICEDISC, "VALEUR.ENCAISSEMENT");
            languagePackage.CreateAlias(BuiltinFunction.PRICEMAT, "PRIX.TITRE.ECHEANCE");
            languagePackage.CreateAlias(BuiltinFunction.PROB, "PROBABILITE");
            languagePackage.CreateAlias(BuiltinFunction.PRODUCT, "PRODUIT");
            languagePackage.CreateAlias(BuiltinFunction.PROPER, "NOMPROPRE");
            languagePackage.CreateAlias(BuiltinFunction.PV, "VA");
            languagePackage.CreateAlias(BuiltinFunction.QUARTILE_EXC, "QUARTILE.EXCLURE");
            languagePackage.CreateAlias(BuiltinFunction.QUARTILE_INC, "QUARTILE.INCLURE");
            languagePackage.CreateAlias(BuiltinFunction.RAND, "ALEA");
            languagePackage.CreateAlias(BuiltinFunction.RANDBETWEEN, "ALEA.ENTRE.BORNES");
            languagePackage.CreateAlias(BuiltinFunction.RANK, "RANG");
            languagePackage.CreateAlias(BuiltinFunction.RANK_AVG, "MOYENNE.RANG");
            languagePackage.CreateAlias(BuiltinFunction.RANK_EQ, "EQUATION.RANG");
            languagePackage.CreateAlias(BuiltinFunction.RATE, "TAUX");
            languagePackage.CreateAlias(BuiltinFunction.RECEIVED, "VALEUR.NOMINALE");
            languagePackage.CreateAlias(BuiltinFunction.REPLACE, "REMPLACER, REMPLACER");
            languagePackage.CreateAlias(BuiltinFunction.REPLACEB, "REMPLACERB, REMPLACERB");
            languagePackage.CreateAlias(BuiltinFunction.RIGHT, "DROITE, DROITE");
            languagePackage.CreateAlias(BuiltinFunction.RIGHTB, "DROITE, DROITEB");
            languagePackage.CreateAlias(BuiltinFunction.ROMAN, "ROMAIN");
            languagePackage.CreateAlias(BuiltinFunction.ROUND, "ARRONDI");
            languagePackage.CreateAlias(BuiltinFunction.ROUNDDOWN, "ARRONDI.INF");
            languagePackage.CreateAlias(BuiltinFunction.ROUNDUP, "ARRONDI.SUP");
            languagePackage.CreateAlias(BuiltinFunction.ROW, "LIGNE");
            languagePackage.CreateAlias(BuiltinFunction.ROWS, "LIGNES");
            languagePackage.CreateAlias(BuiltinFunction.RRI, "TAUX.INT.EQUIV");
            languagePackage.CreateAlias(BuiltinFunction.RSQ, "COEFFICIENT.DETERMINATION");
            languagePackage.CreateAlias(BuiltinFunction.SEARCH, "CHERCHE, CHERCHER");
            languagePackage.CreateAlias(BuiltinFunction.SEARCHB, "CHERCHE, CHERCHERB");
            languagePackage.CreateAlias(BuiltinFunction.SECOND, "SECONDE");
            languagePackage.CreateAlias(BuiltinFunction.SERIESSUM, "SOMME.SERIES");
            languagePackage.CreateAlias(BuiltinFunction.SHEET, "FEUILLE");
            languagePackage.CreateAlias(BuiltinFunction.SIGN, "SIGNE");
            languagePackage.CreateAlias(BuiltinFunction.SKEW, "COEFFICIENT.ASYMETRIE");
            languagePackage.CreateAlias(BuiltinFunction.SLN, "AMORLIN");
            languagePackage.CreateAlias(BuiltinFunction.SLOPE, "PENTE");
            languagePackage.CreateAlias(BuiltinFunction.SMALL, "PETITE.VALEUR");
            languagePackage.CreateAlias(BuiltinFunction.SQRT, "RACINE");
            languagePackage.CreateAlias(BuiltinFunction.SQRTPI, "RACINE.PI");
            languagePackage.CreateAlias(BuiltinFunction.STANDARDIZE, "CENTREE.REDUITE");
            languagePackage.CreateAlias(BuiltinFunction.STDEV, "ECARTYPE");
            languagePackage.CreateAlias(BuiltinFunction.STDEV_P, "ECARTYPE.PEARSON");
            languagePackage.CreateAlias(BuiltinFunction.STDEV_S, "ECARTYPE.STANDARD");
            languagePackage.CreateAlias(BuiltinFunction.STDEVP, "ECARTYPEP");
            languagePackage.CreateAlias(BuiltinFunction.STEYX, "ERREUR.TYPE.XY");
            languagePackage.CreateAlias(BuiltinFunction.SUBSTITUTE, "SUBSTITUE");
            languagePackage.CreateAlias(BuiltinFunction.SUBTOTAL, "SOUS.TOTAL");
            languagePackage.CreateAlias(BuiltinFunction.SUM, "SOMME");
            languagePackage.CreateAlias(BuiltinFunction.SUMIF, "SOMME.SI");
            languagePackage.CreateAlias(BuiltinFunction.SUMIFS, "SOMME.SI.ENS");
            languagePackage.CreateAlias(BuiltinFunction.SUMPRODUCT, "SOMMEPROD");
            languagePackage.CreateAlias(BuiltinFunction.SUMSQ, "SOMME.CARRES");
            languagePackage.CreateAlias(BuiltinFunction.SUMX2MY2, "SOMME.X2MY2");
            languagePackage.CreateAlias(BuiltinFunction.SUMX2PY2, "SOMME.X2PY2");
            languagePackage.CreateAlias(BuiltinFunction.SUMXMY2, "SOMME.XMY2");
            languagePackage.CreateAlias(BuiltinFunction.T_DIST, "LOI.STUDENT.N");
            languagePackage.CreateAlias(BuiltinFunction.T_DIST_2T, "LOI.STUDENT.BILATERALE");
            languagePackage.CreateAlias(BuiltinFunction.T_DIST_RT, "LOI.STUDENT.DROITE");
            languagePackage.CreateAlias(BuiltinFunction.T_INV, "LOI.STUDENT.INVERSE.N");
            languagePackage.CreateAlias(BuiltinFunction.T_INV_2T, "LOI.STUDENT.INVERSE.BILATERALE");
            languagePackage.CreateAlias(BuiltinFunction.TBILLEQ, "TAUX.ESCOMPTE.R");
            languagePackage.CreateAlias(BuiltinFunction.TBILLPRICE, "PRIX.BON.TRESOR");
            languagePackage.CreateAlias(BuiltinFunction.TBILLYIELD, "RENDEMENT.BON.TRESOR");
            languagePackage.CreateAlias(BuiltinFunction.TDIST, "LOI.STUDENT");
            languagePackage.CreateAlias(BuiltinFunction.TEXT, "TEXTE");
            languagePackage.CreateAlias(BuiltinFunction.TIME, "TEMPS");
            languagePackage.CreateAlias(BuiltinFunction.TIMEVALUE, "TEMPSVAL");
            languagePackage.CreateAlias(BuiltinFunction.TINV, "LOI.STUDENT.INVERSE");
            languagePackage.CreateAlias(BuiltinFunction.TODAY, "AUJOURDHUI");
            languagePackage.CreateAlias(BuiltinFunction.TREND, "TENDANCE");
            languagePackage.CreateAlias(BuiltinFunction.TRIM, "SUPPRESPACE");
            languagePackage.CreateAlias(BuiltinFunction.TRIMMEAN, "MOYENNE.REDUITE");
            languagePackage.CreateAlias(BuiltinFunction.TRUE, "VRAI");
            languagePackage.CreateAlias(BuiltinFunction.TRUNC, "TRONQUE");
            languagePackage.CreateAlias(BuiltinFunction.TTEST, "TEST.STUDENT");
            languagePackage.CreateAlias(BuiltinFunction.UNICHAR, "UNICAR");
            languagePackage.CreateAlias(BuiltinFunction.UPPER, "MAJUSCULE");
            languagePackage.CreateAlias(BuiltinFunction.VALUE, "CNUM");
            languagePackage.CreateAlias(BuiltinFunction.VLOOKUP, "RECHERCHEV");
            languagePackage.CreateAlias(BuiltinFunction.WEBSERVICE, "SERVICEWEB");
            languagePackage.CreateAlias(BuiltinFunction.WEEKDAY, "JOURSEM");
            languagePackage.CreateAlias(BuiltinFunction.WEEKNUM, "NO.SEMAINE");
            languagePackage.CreateAlias(BuiltinFunction.WEIBULL, "LOI.WEIBULL");
            languagePackage.CreateAlias(BuiltinFunction.WEIBULL_DIST, "LOI.WEIBULL.N");
            languagePackage.CreateAlias(BuiltinFunction.WORKDAY, "SERIE.JOUR.OUVRE");
            languagePackage.CreateAlias(BuiltinFunction.WORKDAY_INTL, "SERIE.JOUR.OUVRE.INTL");
            languagePackage.CreateAlias(BuiltinFunction.XIRR, "TRI.PAIEMENTS");
            languagePackage.CreateAlias(BuiltinFunction.XNPV, "VAN.PAIEMENTS");
            languagePackage.CreateAlias(BuiltinFunction.XOR, "OUX");
            languagePackage.CreateAlias(BuiltinFunction.YEAR, "ANNEE");
            languagePackage.CreateAlias(BuiltinFunction.YEARFRAC, "FRACTION.ANNEE");
            languagePackage.CreateAlias(BuiltinFunction.YIELD, "RENDEMENT.TITRE");
            languagePackage.CreateAlias(BuiltinFunction.YIELDDISC, "RENDEMENT.SIMPLE");
            languagePackage.CreateAlias(BuiltinFunction.YIELDMAT, "RENDEMENT.TITRE.ECHEANCE");
            languagePackage.CreateAlias(BuiltinFunction.ZTEST, "TEST.Z");
            languagePackage.MapAlias(StructuredItemSpecifiers.All, "Tout");
            languagePackage.MapAlias(StructuredItemSpecifiers.Data, "Données");
            languagePackage.MapAlias(StructuredItemSpecifiers.Headers, "En-têtes");
            languagePackage.MapAlias(StructuredItemSpecifiers.Totals, "Totaux");
            languagePackage.MapAlias(StructuredItemSpecifiers.ThisRow, "Cette ligne");
            return languagePackage;
        }
    }
}


//
//LanguagePackagesDemo.Designer.cs
//


namespace Spread.Calculation.Features
{
    partial class LanguagePackagesDemo
    {
        /// <summary> 
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary> 
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Component Designer generated code

        /// <summary> 
        /// Required method for Designer support - do not modify 
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            components = new System.ComponentModel.Container();
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.menuStrip1 = new System.Windows.Forms.MenuStrip();
            this.languagePackageToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.splitContainer1 = new System.Windows.Forms.SplitContainer();
            this.splitContainer2 = new System.Windows.Forms.SplitContainer();
            this.nameBox1 = new FarPoint.Win.Spread.NameBox();
            this.fpSpread1 = new FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None);
            this.fpSpread1_Sheet1 = new FarPoint.Win.Spread.SheetView();
            this.panel1 = new System.Windows.Forms.Panel();
            this.formulaTextBox1 = new FarPoint.Win.Spread.FormulaTextBox();
            this.menuStrip1.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.splitContainer1)).BeginInit();
            this.splitContainer1.Panel1.SuspendLayout();
            this.splitContainer1.Panel2.SuspendLayout();
            this.splitContainer1.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.splitContainer2)).BeginInit();
            this.splitContainer2.Panel1.SuspendLayout();
            this.splitContainer2.Panel2.SuspendLayout();
            this.splitContainer2.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit();
            this.panel1.SuspendLayout();
            this.pnlMain.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).BeginInit();
            this.SuspendLayout();
            // 
            // pnlMain
            // 
            this.pnlMain.Controls.Add(this.splitContainer1);
            this.pnlMain.Controls.Add(this.menuStrip1);
            // 
            // menuStrip1
            // 
            this.menuStrip1.ImageScalingSize = new System.Drawing.Size(24, 24);
            this.menuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.languagePackageToolStripMenuItem});
            this.menuStrip1.Location = new System.Drawing.Point(0, 0);
            this.menuStrip1.Name = "menuStrip1";
            this.menuStrip1.Size = new System.Drawing.Size(800, 24);
            this.menuStrip1.TabIndex = 0;
            this.menuStrip1.Text = "menuStrip1";
            // 
            // languagePackageToolStripMenuItem
            // 
            this.languagePackageToolStripMenuItem.Name = "languagePackageToolStripMenuItem";
            this.languagePackageToolStripMenuItem.Size = new System.Drawing.Size(118, 20);
            this.languagePackageToolStripMenuItem.Text = "&Language Package";
            // 
            // splitContainer1
            // 
            this.splitContainer1.Dock = System.Windows.Forms.DockStyle.Fill;
            this.splitContainer1.Location = new System.Drawing.Point(0, 24);
            this.splitContainer1.Name = "splitContainer1";
            this.splitContainer1.Orientation = System.Windows.Forms.Orientation.Horizontal;
            // 
            // splitContainer1.Panel1
            // 
            this.splitContainer1.Panel1.Controls.Add(this.splitContainer2);
            this.splitContainer1.Panel1MinSize = 22;
            // 
            // splitContainer1.Panel2
            // 
            this.splitContainer1.Panel2.Controls.Add(this.fpSpread1);
            this.splitContainer1.Size = new System.Drawing.Size(800, 426);
            this.splitContainer1.SplitterDistance = 25;
            this.splitContainer1.TabIndex = 1;
            // 
            // splitContainer2
            // 
            this.splitContainer2.Dock = System.Windows.Forms.DockStyle.Fill;
            this.splitContainer2.Location = new System.Drawing.Point(0, 0);
            this.splitContainer2.Name = "splitContainer2";
            // 
            // splitContainer2.Panel1
            // 
            this.splitContainer2.Panel1.Controls.Add(this.nameBox1);
            this.splitContainer2.Panel1MinSize = 150;
            // 
            // splitContainer2.Panel2
            // 
            this.splitContainer2.Panel2.Controls.Add(this.panel1);
            this.splitContainer2.Size = new System.Drawing.Size(800, 25);
            this.splitContainer2.SplitterDistance = 150;
            this.splitContainer2.TabIndex = 0;
            // 
            // nameBox1
            // 
            this.nameBox1.Dock = System.Windows.Forms.DockStyle.Fill;
            this.nameBox1.Location = new System.Drawing.Point(0, 0);
            this.nameBox1.MaxLength = 255;
            this.nameBox1.Name = "nameBox1";
            this.nameBox1.Size = new System.Drawing.Size(150, 21);
            this.nameBox1.TabIndex = 0;
            // Attach nameBox1 to fpSpread1
            this.nameBox1.Attach(this.fpSpread1);
            // 
            // fpSpread1
            // 
            this.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill;
            this.fpSpread1.Location = new System.Drawing.Point(0, 0);
            this.fpSpread1.Name = "fpSpread1";
            this.fpSpread1.Size = new System.Drawing.Size(800, 397);
            this.fpSpread1.Sheets.Add(fpSpread1_Sheet1);
            this.fpSpread1.TabIndex = 0;
            // 
            // panel1
            // 
            this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
            this.panel1.Controls.Add(this.formulaTextBox1);
            this.panel1.Dock = System.Windows.Forms.DockStyle.Fill;
            this.panel1.Location = new System.Drawing.Point(0, 0);
            this.panel1.Name = "panel1";
            this.panel1.Size = new System.Drawing.Size(646, 25);
            this.panel1.TabIndex = 0;
            // 
            // formulaTextBox1
            // 
            this.formulaTextBox1.BorderStyle = System.Windows.Forms.BorderStyle.None;
            this.formulaTextBox1.Dock = System.Windows.Forms.DockStyle.Fill;
            this.formulaTextBox1.Location = new System.Drawing.Point(0, 0);
            this.formulaTextBox1.Multiline = false;
            this.formulaTextBox1.Name = "formulaTextBox1";
            this.formulaTextBox1.Size = new System.Drawing.Size(644, 23);
            this.formulaTextBox1.TabIndex = 1;
            // Attach formulaTextBox1 to fpSpread1
            this.formulaTextBox1.Attach(this.fpSpread1);
            // 
            // LanguagePackagesDemo
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.Name = "LanguagePackagesDemo";
            this.menuStrip1.ResumeLayout(false);
            this.menuStrip1.PerformLayout();
            this.splitContainer1.Panel1.ResumeLayout(false);
            this.splitContainer1.Panel2.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this.splitContainer1)).EndInit();
            this.splitContainer1.ResumeLayout(false);
            this.splitContainer2.Panel1.ResumeLayout(false);
            this.splitContainer2.Panel2.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this.splitContainer2)).EndInit();
            this.splitContainer2.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit();
            this.panel1.ResumeLayout(false);
            this.pnlMain.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.fpSpread1_Sheet1)).EndInit();
            this.ResumeLayout(false);
        }

        #endregion
        private System.Windows.Forms.MenuStrip menuStrip1;
        private System.Windows.Forms.SplitContainer splitContainer1;
        private System.Windows.Forms.SplitContainer splitContainer2;
        private FarPoint.Win.Spread.NameBox nameBox1;
        private System.Windows.Forms.ToolStripMenuItem languagePackageToolStripMenuItem;
        private FarPoint.Win.Spread.FpSpread fpSpread1;
        private FarPoint.Win.Spread.SheetView fpSpread1_Sheet1;
        private System.Windows.Forms.Panel panel1;
        private FarPoint.Win.Spread.FormulaTextBox formulaTextBox1;
    }
}
